Welcome!

This is an interactive Python notebook that has been made by Washieu Anan and For my project, I wanted to inform others on ways to improve their recycling habits. In this notebook, you will see my statistical analysis of the dataset that we retrieved from NYC OpenData. In this dataset, I was provided with the specific zones that garbage was collected in, the specific districts in which garbage was collected in, the fiscal month in which garbage was collected in, the fiscal year in which garbage was collected in, the total diversion rate of the garbage (per zone and district) and the capture rate of paper that was officially recycled (per zone and district).

In order to understand the purpose of each section of code, please refer to the green lines of text above each section of code. The green lines will help you with understanding each section of our code.

In [2]:
#Below in our first cell, I have imported many crucial Python libraries that are needed to best statistically analyze the data that I have.
import pandas as pd
import numpy as np
import random
import math
import itertools
import seaborn as sns
import matplotlib
import matplotlib.pyplot as plt
plt.style.use('ggplot')
%matplotlib inline
import plotly.graph_objects as go
import plotly.express as px
pd.set_option('display.max_rows', None)
In [0]:
#If you are using Google Colaboratory, please utilize this following cell to upload your .csv files onto your notebooks. 
from google.colab import files
uploaded = files.upload()
Upload widget is only available when the cell has been executed in the current browser session. Please rerun this cell to enable.
Saving Recycling_Diversion_and_Capture_Rates.csv to Recycling_Diversion_and_Capture_Rates.csv
In [3]:
#This following cell tells the computer to take the dataset into the computer and store it as variable. 
df = pd.read_csv("Recycling_Diversion_and_Capture_Rates.csv")
In [4]:
#I did not necessairly have to use the .head() function. We merely wanted to test whether or not our dataset was officially inputted into the system. 
df.head()
Out[4]:
Zone District Fiscal Month Number Fiscal Year Month Name Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
0 Brooklyn North BKN01 10 2019 April 14.7 44.9 43.0 44.1
1 Brooklyn North BKN02 10 2019 April 20.0 34.2 57.9 41.2
2 Brooklyn North BKN03 10 2019 April 12.2 33.5 44.9 38.2
3 Brooklyn North BKN04 10 2019 April 15.5 35.2 68.5 48.8
4 Brooklyn North BKN05 10 2019 April 10.1 22.3 45.1 31.5
In [5]:
#In this cell, I am listing all of the columns within the dataset, for which we have already done in our inductory segment. 
df.columns
Out[5]:
Index(['Zone', 'District', 'Fiscal Month Number', 'Fiscal Year', 'Month Name',
       'Diversion Rate-Total (Total Recycling / Total Waste)',
       'Capture Rate-Paper (Total Paper / Max Paper)',
       'Capture Rate-MGP (Total MGP / Max MGP)',
       'Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100'],
      dtype='object')
In [6]:
df.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2832 entries, 0 to 2831
Data columns (total 9 columns):
 #   Column                                                                                   Non-Null Count  Dtype  
---  ------                                                                                   --------------  -----  
 0   Zone                                                                                     2832 non-null   object 
 1   District                                                                                 2832 non-null   object 
 2   Fiscal Month Number                                                                      2832 non-null   int64  
 3   Fiscal Year                                                                              2832 non-null   int64  
 4   Month Name                                                                               2832 non-null   object 
 5   Diversion Rate-Total (Total Recycling / Total Waste)                                     2832 non-null   float64
 6   Capture Rate-Paper (Total Paper / Max Paper)                                             2832 non-null   float64
 7   Capture Rate-MGP (Total MGP / Max MGP)                                                   2832 non-null   float64
 8   Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100  2832 non-null   float64
dtypes: float64(4), int64(2), object(3)
memory usage: 199.2+ KB
In [7]:
#In this cell, I am telling the computer to read each columns as a string of letters rather than a number that has been located within an array. 
df['Fiscal_Date'] = df['Fiscal Year'].astype(str) + '-' + df['Fiscal Month Number'].astype(str)
df['Fiscal_Date'] = pd.to_datetime(df['Fiscal_Date'])
df['Normal_Date'] = df['Fiscal Year'].astype(str) + '-' + df['Month Name']
df['Normal_Date'] = pd.to_datetime(df['Normal_Date'])
In [8]:
#In this cell, I outline the specific zones that are available. 
df.Zone.unique()
Out[8]:
array(['Brooklyn North', 'Brooklyn South', 'Bronx', 'Manhattan',
       'Queens East', 'Queens West', 'Staten Island'], dtype=object)
In [9]:
#In this cell, I am renaming each of the zones to look much cleaner in appearance when being shown to the public. 
df_brooklyn_north = df[df['Zone'] == 'Brooklyn North']
df_brooklyn_south = df[df['Zone'] == 'Brooklyn South']
df_bronx = df[df['Zone'] == 'Bronx']
df_manhattan = df[df['Zone'] == 'Manhattan']
df_queens_east = df[df['Zone'] == 'Queens East']
df_queens_west = df[df['Zone'] == 'Queens West']
df_staten_island = df[df['Zone'] == 'Staten Island']
In [10]:
#In this cell, I am creating a list in which we list all of the specific zones. 
zone_list = [df_brooklyn_north, df_brooklyn_south, df_bronx, df_manhattan, df_queens_east, df_queens_west, df_staten_island]
In [11]:
#In this cell, I am telling the computer to go through each zone. While going through each zone, 
#I am telling the commputer to define the shape (the number of rows) and the name of the zone that corresponds with it. 
for df_zone in zone_list:
    shape = df_zone.shape
    zone_name = df_zone.Zone.unique()[0]
    print(zone_name, shape[0])
    
Brooklyn North 432
Brooklyn South 432
Bronx 576
Manhattan 576
Queens East 336
Queens West 336
Staten Island 144
In [12]:
#In this cell, I am telling the computer to tell us the number of districts within this dataset. 
districts = []
for zone in df.Zone.unique():
    zone_df = df[df['Zone'] == zone]
    count = 0
    for district in zone_df.District.unique():
      districts.append(district)
      
len(districts)
Out[12]:
59
In [13]:
#In this cell, I am telling the computer to go through each zone and district and create a "scatter plot" that contains a line for the:
#Total Diversion Rate, Total Capture Rate of Paper, Total Capture Rate of Metal, Glass, and Plastic, Overall Capture Rate. 
#If you hover over a line, it will provide you with the specific name of the line that you are hovering over. 
for zone in df.Zone.unique():
    zone_df = df[df['Zone'] == zone]
    count = 0
    for district in zone_df.District.unique():
        district_df = zone_df[zone_df['District'] == district]
        district_df = district_df.sort_values(by=['Normal_Date'])
        fig = go.Figure()
        fig.add_trace(go.Scatter(
                        x=district_df.Normal_Date,
                        y=district_df['Diversion Rate-Total (Total Recycling / Total Waste)'],
                        name=f"'Diversion Rate-Total' - {district_df.District.unique()[0]}",
                        line_color='deepskyblue',
                        opacity=0.8))

        fig.add_trace(go.Scatter(
                        x=district_df.Normal_Date,
                        y=district_df['Capture Rate-Paper (Total Paper / Max Paper)'],
                        name=f"'Capture Rate-Paper' - {district_df.District.unique()[0]}",
                        line_color='firebrick',
                        opacity=0.8))

        fig.add_trace(go.Scatter(
                        x=district_df.Normal_Date,
                        y=district_df['Capture Rate-MGP (Total MGP / Max MGP)'],
                        name=f"'Capture Rate-MGP' - {district_df.District.unique()[0]}",
                        line_color='green',
                        opacity=0.8))
        
        fig.add_trace(go.Scatter(
                        x=district_df.Normal_Date,
                        y=district_df['Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100'],
                        name=f"'Capture Rate-Total' - {district_df.District.unique()[0]}",
                        line_color='rgb(102,102,255)',
                        opacity=0.8))

        fig.update_layout(xaxis_range=[min(district_df.Normal_Date),max(district_df.Normal_Date)],
                          title_text=f"'Rates for District ' + {district_df.District.unique()[0]}",xaxis_title="Date",
            yaxis_title="Rate",
                        xaxis_rangeslider_visible=True)
        fig.show()
        
In [14]:
#In this cell, I am finding the mean, standard deviation, minimum, maximum, and percentages of the data to better analyze the type of data that I am looking at. 
for zone in df.Zone.unique():
    zone_df = df[df['Zone'] == zone]
    count = 0
    for district in zone_df.District.unique():
        district_df = zone_df[zone_df['District'] == district]
        district_df = district_df.sort_values(by=['Normal_Date'])
        print(district + '  statistics')
        display(district_df.describe())
        print('\n\n\n')
BKN01  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 15.354167 48.291667 45.754167 47.129167
std 3.488583 1.129865 0.917202 4.008174 2.807131 2.605229
min 1.000000 2016.000000 13.500000 40.500000 39.900000 41.300000
25% 3.750000 2016.750000 14.700000 45.350000 43.925000 45.450000
50% 6.500000 2017.500000 15.350000 48.250000 46.050000 47.400000
75% 9.250000 2018.250000 16.025000 51.125000 47.125000 48.850000
max 12.000000 2019.000000 17.100000 58.400000 55.400000 52.900000



BKN02  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 19.262500 33.537500 56.170833 40.016667
std 3.488583 1.129865 1.489056 2.025752 3.015701 2.041832
min 1.000000 2016.000000 16.500000 28.200000 49.100000 34.400000
25% 3.750000 2016.750000 17.900000 32.400000 54.125000 38.850000
50% 6.500000 2017.500000 19.450000 33.550000 56.450000 40.000000
75% 9.250000 2018.250000 20.425000 34.550000 57.925000 41.200000
max 12.000000 2019.000000 22.500000 38.000000 63.800000 43.900000



BKN03  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 11.820833 34.677083 41.362500 37.472917
std 3.488583 1.129865 0.823836 3.078217 3.643743 2.744491
min 1.000000 2016.000000 10.100000 29.000000 32.800000 30.800000
25% 3.750000 2016.750000 11.300000 32.450000 39.525000 35.675000
50% 6.500000 2017.500000 11.800000 34.750000 41.400000 37.650000
75% 9.250000 2018.250000 12.325000 36.625000 43.775000 39.375000
max 12.000000 2019.000000 13.900000 41.800000 49.200000 42.900000



BKN04  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 14.685417 35.391667 61.737500 46.562500
std 3.488583 1.129865 1.127601 3.103041 6.137559 3.631636
min 1.000000 2016.000000 12.400000 30.300000 46.400000 37.800000
25% 3.750000 2016.750000 13.900000 32.500000 58.575000 44.075000
50% 6.500000 2017.500000 14.500000 35.850000 62.600000 47.150000
75% 9.250000 2018.250000 15.600000 37.525000 67.200000 49.275000
max 12.000000 2019.000000 17.100000 42.600000 73.800000 53.200000



BKN05  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 10.052083 24.845833 41.368750 31.837500
std 3.488583 1.129865 0.640807 2.081423 3.914792 2.160243
min 1.000000 2016.000000 9.000000 21.100000 33.000000 27.200000
25% 3.750000 2016.750000 9.600000 23.400000 38.975000 30.125000
50% 6.500000 2017.500000 9.950000 24.650000 41.400000 31.700000
75% 9.250000 2018.250000 10.400000 26.600000 43.825000 33.425000
max 12.000000 2019.000000 11.700000 29.100000 50.700000 36.700000



BKN08  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 16.189583 46.272917 54.987500 49.891667
std 3.488583 1.129865 1.177310 3.927521 5.092449 3.570972
min 1.000000 2016.000000 13.800000 36.100000 45.000000 40.300000
25% 3.750000 2016.750000 15.400000 43.675000 51.850000 47.200000
50% 6.500000 2017.500000 16.150000 46.300000 54.950000 50.600000
75% 9.250000 2018.250000 16.825000 49.075000 58.725000 52.400000
max 12.000000 2019.000000 19.800000 56.500000 67.300000 57.900000



BKN09  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 12.770833 31.797917 44.543750 36.431250
std 3.488583 1.129865 1.010784 1.653171 3.684927 1.959717
min 1.000000 2016.000000 10.900000 27.700000 38.100000 31.800000
25% 3.750000 2016.750000 11.975000 30.975000 42.050000 35.200000
50% 6.500000 2017.500000 12.700000 32.050000 44.500000 36.850000
75% 9.250000 2018.250000 13.700000 32.925000 47.050000 37.925000
max 12.000000 2019.000000 14.900000 34.600000 52.200000 39.700000



BKN16  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 9.054167 22.777083 33.325000 27.235417
std 3.488583 1.129865 0.735703 1.785311 2.910838 1.627227
min 1.000000 2016.000000 7.700000 20.300000 27.000000 23.500000
25% 3.750000 2016.750000 8.375000 21.350000 31.475000 26.150000
50% 6.500000 2017.500000 9.250000 22.150000 32.950000 27.150000
75% 9.250000 2018.250000 9.600000 24.450000 35.425000 28.200000
max 12.000000 2019.000000 10.800000 26.700000 39.000000 31.300000



BKN17  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 13.745833 28.452083 60.993750 40.345833
std 3.488583 1.129865 0.852770 1.410747 5.261882 1.950336
min 1.000000 2016.000000 12.300000 25.300000 51.900000 35.400000
25% 3.750000 2016.750000 13.200000 27.600000 57.150000 38.900000
50% 6.500000 2017.500000 13.500000 28.400000 60.600000 40.300000
75% 9.250000 2018.250000 14.200000 29.125000 65.850000 41.725000
max 12.000000 2019.000000 15.900000 32.200000 72.100000 43.900000



BKS06  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.00000
mean 6.500000 2017.500000 29.637500 46.445833 82.327083 56.71875
std 3.488583 1.129865 1.521285 2.307431 3.695008 2.36118
min 1.000000 2016.000000 26.200000 41.300000 75.000000 50.90000
25% 3.750000 2016.750000 29.000000 44.925000 81.050000 55.50000
50% 6.500000 2017.500000 29.700000 46.450000 82.350000 57.05000
75% 9.250000 2018.250000 30.250000 47.825000 85.000000 58.15000
max 12.000000 2019.000000 33.800000 52.200000 95.700000 64.50000



BKS07  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 21.612500 48.189583 71.645833 56.712500
std 3.488583 1.129865 1.633639 6.561209 6.870596 4.721144
min 1.000000 2016.000000 18.700000 36.400000 59.700000 44.900000
25% 3.750000 2016.750000 20.300000 44.900000 67.575000 53.550000
50% 6.500000 2017.500000 21.050000 46.200000 71.050000 56.300000
75% 9.250000 2018.250000 22.825000 49.650000 75.500000 58.425000
max 12.000000 2019.000000 25.400000 72.600000 89.900000 74.000000



BKS10  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.00000 48.000000
mean 6.500000 2017.500000 24.662500 54.939583 77.30625 63.077083
std 3.488583 1.129865 1.181889 3.154041 6.44378 3.026636
min 1.000000 2016.000000 22.300000 45.900000 63.00000 52.900000
25% 3.750000 2016.750000 23.900000 53.350000 73.20000 61.275000
50% 6.500000 2017.500000 24.450000 55.250000 77.40000 63.150000
75% 9.250000 2018.250000 25.600000 57.000000 80.82500 65.225000
max 12.000000 2019.000000 27.300000 61.000000 90.50000 68.900000



BKS11  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 19.012500 46.158333 64.264583 52.735417
std 3.488583 1.129865 1.339518 2.614675 5.458606 2.586914
min 1.000000 2016.000000 15.900000 38.000000 52.700000 43.800000
25% 3.750000 2016.750000 18.100000 44.700000 61.600000 51.025000
50% 6.500000 2017.500000 18.850000 46.550000 64.000000 53.550000
75% 9.250000 2018.250000 20.100000 47.525000 68.400000 54.425000
max 12.000000 2019.000000 21.300000 53.400000 73.400000 59.700000



BKS12  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.00000 48.000000
mean 6.500000 2017.500000 15.250000 50.750000 42.31250 47.047917
std 3.488583 1.129865 0.900118 4.284758 3.45787 2.651935
min 1.000000 2016.000000 12.700000 42.400000 33.80000 39.800000
25% 3.750000 2016.750000 14.600000 47.825000 40.30000 44.975000
50% 6.500000 2017.500000 15.400000 50.200000 42.40000 47.000000
75% 9.250000 2018.250000 15.700000 52.500000 44.80000 48.900000
max 12.000000 2019.000000 17.400000 61.900000 48.20000 55.000000



BKS13  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 14.197917 41.304167 49.466667 44.879167
std 3.488583 1.129865 0.846140 2.683199 3.030086 2.198932
min 1.000000 2016.000000 12.100000 35.500000 41.200000 38.700000
25% 3.750000 2016.750000 13.775000 39.675000 47.975000 44.075000
50% 6.500000 2017.500000 14.350000 40.900000 49.900000 45.150000
75% 9.250000 2018.250000 14.725000 43.100000 51.525000 46.100000
max 12.000000 2019.000000 15.800000 47.600000 56.500000 49.300000



BKS14  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 14.783333 34.087500 53.647917 40.397917
std 3.488583 1.129865 1.030252 2.772327 3.516042 2.836351
min 1.000000 2016.000000 13.000000 25.200000 44.300000 31.200000
25% 3.750000 2016.750000 14.100000 32.200000 51.850000 39.100000
50% 6.500000 2017.500000 14.750000 33.750000 53.700000 40.200000
75% 9.250000 2018.250000 15.300000 35.875000 55.825000 42.225000
max 12.000000 2019.000000 17.600000 39.900000 62.800000 47.500000



BKS15  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.00000 48.000000 48.000000
mean 6.500000 2017.500000 18.945833 47.95000 62.222917 53.125000
std 3.488583 1.129865 1.388855 2.42171 4.970048 2.492585
min 1.000000 2016.000000 16.500000 40.30000 51.900000 44.500000
25% 3.750000 2016.750000 17.775000 46.60000 59.500000 51.100000
50% 6.500000 2017.500000 19.000000 47.70000 62.100000 53.800000
75% 9.250000 2018.250000 19.825000 49.32500 66.325000 54.800000
max 12.000000 2019.000000 22.300000 54.10000 72.200000 58.800000



BKS18  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 15.572917 34.702083 65.187500 44.850000
std 3.488583 1.129865 1.205614 3.750092 5.388744 4.109304
min 1.000000 2016.000000 13.700000 28.400000 54.700000 36.800000
25% 3.750000 2016.750000 14.700000 32.050000 61.575000 42.225000
50% 6.500000 2017.500000 15.150000 33.650000 65.550000 43.850000
75% 9.250000 2018.250000 16.000000 37.250000 68.875000 47.850000
max 12.000000 2019.000000 19.100000 42.900000 75.600000 53.300000



BX01  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 6.831250 19.479167 25.477083 22.106250
std 3.488583 1.129865 0.516599 1.724043 1.895935 1.594726
min 1.000000 2016.000000 5.900000 16.900000 20.400000 18.500000
25% 3.750000 2016.750000 6.500000 17.975000 24.600000 21.075000
50% 6.500000 2017.500000 6.800000 19.550000 25.700000 22.100000
75% 9.250000 2018.250000 7.100000 20.600000 26.525000 22.850000
max 12.000000 2019.000000 8.500000 24.200000 29.800000 26.700000



BX02  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 12.860417 32.747917 53.379167 41.802083
std 3.488583 1.129865 0.779181 2.861334 3.692198 2.655744
min 1.000000 2016.000000 10.100000 25.600000 42.900000 33.200000
25% 3.750000 2016.750000 12.500000 30.825000 51.100000 40.425000
50% 6.500000 2017.500000 13.000000 32.600000 53.150000 41.950000
75% 9.250000 2018.250000 13.400000 34.450000 56.050000 43.625000
max 12.000000 2019.000000 14.200000 40.600000 60.500000 47.600000



BX03  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 9.275000 25.375000 36.387500 30.204167
std 3.488583 1.129865 0.737304 2.473132 3.248347 2.417574
min 1.000000 2016.000000 7.600000 19.800000 29.500000 24.200000
25% 3.750000 2016.750000 8.700000 23.375000 34.275000 28.375000
50% 6.500000 2017.500000 9.100000 25.450000 35.850000 30.000000
75% 9.250000 2018.250000 9.800000 27.300000 37.800000 31.725000
max 12.000000 2019.000000 11.100000 31.100000 43.200000 35.500000



BX04  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 11.310417 28.714583 46.562500 36.547917
std 3.488583 1.129865 0.886120 2.106423 4.275692 2.664262
min 1.000000 2016.000000 9.600000 24.800000 35.700000 29.800000
25% 3.750000 2016.750000 10.875000 27.100000 44.500000 35.400000
50% 6.500000 2017.500000 11.250000 28.400000 47.200000 36.600000
75% 9.250000 2018.250000 11.900000 30.325000 48.925000 37.925000
max 12.000000 2019.000000 13.700000 33.300000 56.300000 43.300000



BX05  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 11.414583 27.264583 49.795833 37.160417
std 3.488583 1.129865 0.526728 2.023110 2.800833 1.810459
min 1.000000 2016.000000 10.400000 23.800000 43.200000 32.900000
25% 3.750000 2016.750000 11.100000 25.775000 47.725000 35.800000
50% 6.500000 2017.500000 11.300000 27.200000 49.700000 36.850000
75% 9.250000 2018.250000 11.725000 28.525000 52.100000 38.350000
max 12.000000 2019.000000 13.100000 32.100000 55.900000 42.300000



BX06  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 13.581250 35.385417 44.070833 39.197917
std 3.488583 1.129865 1.079727 2.318381 4.575465 2.956024
min 1.000000 2016.000000 11.000000 29.800000 31.600000 30.600000
25% 3.750000 2016.750000 13.125000 33.750000 42.375000 37.600000
50% 6.500000 2017.500000 13.900000 35.550000 44.100000 39.000000
75% 9.250000 2018.250000 14.100000 36.800000 45.550000 40.500000
max 12.000000 2019.000000 16.300000 40.900000 54.400000 46.900000



BX07  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 14.000000 33.775000 60.731250 45.610417
std 3.488583 1.129865 0.844759 2.405977 4.416659 2.787452
min 1.000000 2016.000000 12.200000 29.000000 49.800000 38.300000
25% 3.750000 2016.750000 13.450000 32.250000 58.325000 44.375000
50% 6.500000 2017.500000 14.100000 33.300000 61.050000 45.750000
75% 9.250000 2018.250000 14.500000 35.475000 63.325000 47.350000
max 12.000000 2019.000000 16.100000 38.500000 70.300000 51.700000



BX08  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 20.733333 42.702083 79.535417 54.587500
std 3.488583 1.129865 1.080452 3.426337 4.201696 3.268523
min 1.000000 2016.000000 18.200000 35.000000 64.300000 44.200000
25% 3.750000 2016.750000 20.000000 40.175000 77.200000 52.400000
50% 6.500000 2017.500000 20.500000 42.600000 79.900000 54.550000
75% 9.250000 2018.250000 21.400000 44.825000 81.600000 56.925000
max 12.000000 2019.000000 23.700000 49.700000 89.100000 61.100000



BX09  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 9.739583 23.566667 40.614583 30.791667
std 3.488583 1.129865 0.611847 1.610515 3.681061 1.780131
min 1.000000 2016.000000 8.200000 20.800000 32.100000 26.900000
25% 3.750000 2016.750000 9.400000 22.275000 38.525000 29.500000
50% 6.500000 2017.500000 9.700000 23.300000 40.650000 31.150000
75% 9.250000 2018.250000 10.025000 25.125000 43.325000 32.050000
max 12.000000 2019.000000 11.400000 26.600000 47.800000 34.000000



BX10  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 19.625000 41.350000 72.295833 52.672917
std 3.488583 1.129865 1.444947 2.665541 7.969035 2.307503
min 1.000000 2016.000000 17.700000 36.000000 59.400000 47.200000
25% 3.750000 2016.750000 18.200000 39.400000 66.100000 51.025000
50% 6.500000 2017.500000 20.050000 41.700000 71.500000 52.850000
75% 9.250000 2018.250000 20.825000 42.800000 78.200000 54.225000
max 12.000000 2019.000000 22.200000 47.700000 88.600000 57.000000



BX11  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 15.577083 34.262500 56.575000 42.400000
std 3.488583 1.129865 1.687657 1.744368 4.731942 1.883975
min 1.000000 2016.000000 12.800000 30.100000 47.500000 36.900000
25% 3.750000 2016.750000 13.900000 33.200000 53.450000 41.275000
50% 6.500000 2017.500000 15.700000 34.450000 55.700000 42.450000
75% 9.250000 2018.250000 16.900000 35.300000 60.675000 43.625000
max 12.000000 2019.000000 18.900000 39.300000 65.300000 47.300000



BX12  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 18.431250 33.950000 75.866667 49.281250
std 3.488583 1.129865 2.390153 1.589995 6.330753 2.345358
min 1.000000 2016.000000 14.700000 29.400000 62.900000 42.100000
25% 3.750000 2016.750000 16.300000 33.000000 71.425000 47.600000
50% 6.500000 2017.500000 17.950000 33.900000 74.450000 49.350000
75% 9.250000 2018.250000 20.450000 35.050000 80.700000 51.225000
max 12.000000 2019.000000 22.700000 37.200000 87.600000 53.400000



MN01  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 27.150000 45.008333 71.364583 51.491667
std 3.488583 1.129865 1.134001 1.959031 5.943725 2.053729
min 1.000000 2016.000000 25.100000 40.900000 57.800000 47.500000
25% 3.750000 2016.750000 26.375000 43.675000 67.325000 49.950000
50% 6.500000 2017.500000 27.150000 44.800000 71.800000 51.750000
75% 9.250000 2018.250000 27.825000 45.975000 75.525000 52.800000
max 12.000000 2019.000000 30.100000 50.200000 84.100000 56.500000



MN02  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 25.850000 39.018750 79.441667 48.987500
std 3.488583 1.129865 1.655037 2.197741 6.223081 2.572409
min 1.000000 2016.000000 22.000000 34.300000 64.700000 42.700000
25% 3.750000 2016.750000 24.575000 37.575000 75.250000 47.550000
50% 6.500000 2017.500000 25.800000 38.950000 80.250000 49.100000
75% 9.250000 2018.250000 27.025000 40.100000 84.225000 50.850000
max 12.000000 2019.000000 29.800000 43.800000 89.200000 54.300000



MN03  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 14.179167 43.060417 42.877083 42.966667
std 3.488583 1.129865 0.721688 2.306673 2.050972 1.652636
min 1.000000 2016.000000 12.600000 38.100000 38.200000 39.700000
25% 3.750000 2016.750000 13.800000 41.150000 41.850000 41.850000
50% 6.500000 2017.500000 14.200000 43.000000 42.800000 43.100000
75% 9.250000 2018.250000 14.625000 44.700000 44.025000 43.900000
max 12.000000 2019.000000 15.700000 48.000000 48.300000 48.100000



MN04  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 22.691667 33.087500 75.279167 43.516667
std 3.488583 1.129865 0.908315 1.417763 4.467802 1.281345
min 1.000000 2016.000000 20.800000 30.100000 66.100000 40.400000
25% 3.750000 2016.750000 22.100000 31.900000 72.600000 42.725000
50% 6.500000 2017.500000 22.600000 33.300000 74.700000 43.650000
75% 9.250000 2018.250000 23.325000 33.900000 78.600000 44.275000
max 12.000000 2019.000000 24.800000 36.700000 83.600000 45.800000



MN05  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 19.870833 31.589583 59.195833 38.406250
std 3.488583 1.129865 1.415711 2.232281 4.971577 2.399947
min 1.000000 2016.000000 17.100000 27.500000 46.500000 33.200000
25% 3.750000 2016.750000 18.950000 30.150000 57.075000 37.025000
50% 6.500000 2017.500000 19.750000 31.350000 60.300000 38.350000
75% 9.250000 2018.250000 20.900000 33.625000 62.625000 40.100000
max 12.000000 2019.000000 24.100000 36.300000 68.200000 44.500000



MN06  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 22.808333 34.204167 71.662500 43.458333
std 3.488583 1.129865 1.088593 1.692909 4.326692 1.585685
min 1.000000 2016.000000 20.700000 31.300000 61.400000 40.300000
25% 3.750000 2016.750000 22.100000 32.900000 69.250000 42.450000
50% 6.500000 2017.500000 22.650000 34.250000 72.450000 43.600000
75% 9.250000 2018.250000 23.625000 35.000000 74.850000 44.200000
max 12.000000 2019.000000 25.200000 39.300000 79.400000 47.100000



MN07  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 26.920833 41.900000 77.679167 50.727083
std 3.488583 1.129865 1.188591 1.747338 5.344791 1.866928
min 1.000000 2016.000000 23.900000 39.000000 64.400000 45.900000
25% 3.750000 2016.750000 26.100000 41.000000 74.200000 49.975000
50% 6.500000 2017.500000 26.950000 41.500000 79.250000 50.650000
75% 9.250000 2018.250000 27.600000 42.625000 81.800000 51.550000
max 12.000000 2019.000000 29.800000 46.900000 86.600000 55.900000



MN08  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 26.297917 42.120833 76.141667 50.514583
std 3.488583 1.129865 1.091454 1.929387 5.070811 1.916223
min 1.000000 2016.000000 23.900000 38.800000 64.000000 46.100000
25% 3.750000 2016.750000 25.600000 40.700000 73.325000 49.400000
50% 6.500000 2017.500000 26.150000 41.950000 77.850000 50.650000
75% 9.250000 2018.250000 26.900000 43.050000 80.350000 51.825000
max 12.000000 2019.000000 29.100000 47.300000 83.600000 55.400000



MN09  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.00000
mean 6.500000 2017.500000 17.960417 56.456250 48.410417 52.91875
std 3.488583 1.129865 1.002495 2.851943 2.294141 1.95988
min 1.000000 2016.000000 15.000000 51.300000 42.000000 48.00000
25% 3.750000 2016.750000 17.275000 54.725000 47.450000 51.70000
50% 6.500000 2017.500000 18.200000 55.850000 48.500000 52.95000
75% 9.250000 2018.250000 18.700000 58.625000 49.825000 54.22500
max 12.000000 2019.000000 19.500000 67.400000 53.400000 58.50000



MN10  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 14.527083 39.041667 54.039583 45.622917
std 3.488583 1.129865 0.757864 2.352801 2.933210 2.066474
min 1.000000 2016.000000 12.700000 33.900000 45.300000 40.000000
25% 3.750000 2016.750000 14.200000 38.175000 52.500000 44.500000
50% 6.500000 2017.500000 14.450000 38.950000 54.700000 45.800000
75% 9.250000 2018.250000 14.900000 40.000000 56.025000 46.925000
max 12.000000 2019.000000 16.700000 44.700000 58.800000 49.200000



MN11  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 11.520833 41.041667 31.581250 36.881250
std 3.488583 1.129865 0.447194 2.109939 1.378506 1.446295
min 1.000000 2016.000000 10.700000 37.600000 28.800000 34.000000
25% 3.750000 2016.750000 11.275000 39.050000 30.775000 35.800000
50% 6.500000 2017.500000 11.450000 41.200000 31.500000 36.900000
75% 9.250000 2018.250000 11.800000 42.350000 32.600000 37.800000
max 12.000000 2019.000000 12.600000 44.800000 35.000000 40.300000



MN12  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.00000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 16.08750 44.845833 57.650000 50.472917
std 3.488583 1.129865 0.81047 2.544745 2.294211 2.079560
min 1.000000 2016.000000 14.80000 41.000000 53.900000 47.200000
25% 3.750000 2016.750000 15.57500 43.400000 56.075000 49.100000
50% 6.500000 2017.500000 15.90000 44.800000 57.200000 50.350000
75% 9.250000 2018.250000 16.40000 45.475000 58.825000 51.325000
max 12.000000 2019.000000 18.40000 53.600000 66.600000 57.900000



QE07  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 19.487500 47.762500 64.606250 53.883333
std 3.488583 1.129865 1.952372 1.698263 5.491673 2.261833
min 1.000000 2016.000000 16.300000 44.700000 51.100000 49.200000
25% 3.750000 2016.750000 17.650000 46.775000 61.975000 52.375000
50% 6.500000 2017.500000 19.650000 47.450000 65.050000 54.250000
75% 9.250000 2018.250000 20.750000 48.900000 69.000000 55.775000
max 12.000000 2019.000000 23.400000 52.000000 74.000000 57.900000



QE08  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 16.868750 28.877083 52.031250 35.500000
std 3.488583 1.129865 1.771062 1.835030 4.157083 2.100253
min 1.000000 2016.000000 14.100000 26.100000 43.300000 31.300000
25% 3.750000 2016.750000 15.675000 27.725000 49.775000 34.175000
50% 6.500000 2017.500000 16.450000 28.400000 51.800000 35.100000
75% 9.250000 2018.250000 17.500000 29.750000 54.025000 36.275000
max 12.000000 2019.000000 22.000000 34.000000 66.600000 43.300000



QE10  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 20.508333 37.710417 82.993750 52.783333
std 3.488583 1.129865 2.079672 3.910773 7.244907 4.689705
min 1.000000 2016.000000 15.900000 32.000000 63.500000 46.200000
25% 3.750000 2016.750000 19.400000 34.700000 78.275000 49.450000
50% 6.500000 2017.500000 20.450000 36.700000 82.350000 51.500000
75% 9.250000 2018.250000 21.400000 40.500000 88.175000 55.500000
max 12.000000 2019.000000 26.000000 46.800000 97.600000 62.600000



QE11  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 24.900000 54.500000 82.660417 63.850000
std 3.488583 1.129865 3.100172 5.189146 6.870465 5.512963
min 1.000000 2016.000000 18.600000 46.400000 70.300000 53.900000
25% 3.750000 2016.750000 22.300000 51.000000 77.725000 60.600000
50% 6.500000 2017.500000 24.750000 53.350000 81.850000 62.100000
75% 9.250000 2018.250000 26.400000 56.425000 87.325000 67.525000
max 12.000000 2019.000000 32.800000 65.200000 97.200000 75.500000



QE12  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 14.420833 34.302083 66.714583 48.204167
std 3.488583 1.129865 1.333362 2.471152 6.671693 2.779940
min 1.000000 2016.000000 12.500000 30.100000 50.000000 42.000000
25% 3.750000 2016.750000 13.600000 32.400000 63.625000 46.200000
50% 6.500000 2017.500000 14.000000 34.000000 66.350000 48.750000
75% 9.250000 2018.250000 14.800000 36.150000 70.875000 49.850000
max 12.000000 2019.000000 17.800000 39.300000 79.200000 55.100000



QE13  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 19.297917 34.647917 86.616667 51.945833
std 3.488583 1.129865 2.300554 3.607203 7.000496 4.313066
min 1.000000 2016.000000 15.800000 28.500000 71.400000 45.700000
25% 3.750000 2016.750000 17.350000 31.925000 82.400000 48.800000
50% 6.500000 2017.500000 18.800000 34.150000 87.200000 50.650000
75% 9.250000 2018.250000 21.200000 37.425000 91.825000 56.200000
max 12.000000 2019.000000 23.900000 44.200000 100.300000 60.900000



QE14  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 12.687500 31.156250 42.268750 35.216667
std 3.488583 1.129865 1.514978 1.857464 4.449822 2.320155
min 1.000000 2016.000000 10.400000 27.700000 33.000000 30.300000
25% 3.750000 2016.750000 11.400000 29.975000 39.500000 33.900000
50% 6.500000 2017.500000 12.600000 31.100000 41.750000 35.450000
75% 9.250000 2018.250000 13.925000 32.250000 44.925000 36.825000
max 12.000000 2019.000000 16.100000 35.100000 52.600000 40.500000



QW01  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 20.004167 48.947917 76.022917 58.800000
std 3.488583 1.129865 1.086074 2.045232 6.462634 2.555178
min 1.000000 2016.000000 18.400000 44.200000 62.300000 53.700000
25% 3.750000 2016.750000 19.400000 47.725000 71.200000 56.850000
50% 6.500000 2017.500000 19.800000 49.300000 74.700000 59.350000
75% 9.250000 2018.250000 20.225000 50.300000 81.575000 60.300000
max 12.000000 2019.000000 23.500000 53.200000 86.900000 65.000000



QW02  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 20.741667 50.675000 73.127083 58.831250
std 3.488583 1.129865 1.410573 2.140143 6.207262 2.349482
min 1.000000 2016.000000 18.600000 45.200000 60.200000 54.300000
25% 3.750000 2016.750000 19.500000 49.250000 68.825000 56.775000
50% 6.500000 2017.500000 20.550000 50.950000 72.150000 58.900000
75% 9.250000 2018.250000 21.700000 51.900000 76.525000 60.525000
max 12.000000 2019.000000 24.000000 56.000000 90.300000 63.000000



QW03  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.00000 48.000000 48.000000
mean 6.500000 2017.500000 14.527083 31.68125 61.818750 42.689583
std 3.488583 1.129865 0.844693 1.60831 5.059335 1.712065
min 1.000000 2016.000000 13.300000 28.90000 48.700000 38.600000
25% 3.750000 2016.750000 13.900000 30.40000 58.300000 41.500000
50% 6.500000 2017.500000 14.350000 31.60000 62.000000 42.700000
75% 9.250000 2018.250000 14.925000 32.70000 65.050000 43.900000
max 12.000000 2019.000000 16.300000 36.60000 70.700000 45.600000



QW04  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 14.800000 34.122917 60.087500 43.585417
std 3.488583 1.129865 0.964916 1.748828 6.736298 2.700433
min 1.000000 2016.000000 12.700000 30.500000 43.900000 37.100000
25% 3.750000 2016.750000 14.375000 33.075000 56.125000 41.600000
50% 6.500000 2017.500000 14.850000 34.200000 60.850000 43.750000
75% 9.250000 2018.250000 15.325000 35.225000 64.450000 45.800000
max 12.000000 2019.000000 16.800000 37.900000 71.300000 47.600000



QW05  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 24.512500 47.554167 86.906250 61.945833
std 3.488583 1.129865 1.564585 2.900547 6.377567 2.491087
min 1.000000 2016.000000 22.200000 42.800000 73.000000 56.100000
25% 3.750000 2016.750000 23.550000 45.400000 83.075000 60.275000
50% 6.500000 2017.500000 24.200000 47.550000 86.100000 61.900000
75% 9.250000 2018.250000 25.000000 49.300000 90.725000 63.800000
max 12.000000 2019.000000 29.200000 56.000000 101.800000 68.200000



QW06  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 21.185417 30.485417 71.264583 40.550000
std 3.488583 1.129865 1.228905 1.610338 4.760542 1.328733
min 1.000000 2016.000000 19.700000 28.100000 59.400000 38.500000
25% 3.750000 2016.750000 20.300000 29.500000 67.675000 39.600000
50% 6.500000 2017.500000 20.700000 30.150000 72.200000 40.200000
75% 9.250000 2018.250000 21.825000 30.875000 75.000000 41.125000
max 12.000000 2019.000000 24.200000 35.700000 78.200000 44.200000



QW09  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 20.512500 40.970833 76.920833 54.108333
std 3.488583 1.129865 2.568104 2.256146 5.742338 2.132009
min 1.000000 2016.000000 16.600000 36.900000 62.600000 49.600000
25% 3.750000 2016.750000 18.200000 39.575000 73.100000 52.375000
50% 6.500000 2017.500000 20.400000 40.850000 76.600000 54.150000
75% 9.250000 2018.250000 22.325000 42.150000 80.275000 56.000000
max 12.000000 2019.000000 26.100000 47.200000 88.500000 58.400000



SI01  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 20.156250 40.362500 75.895833 52.195833
std 3.488583 1.129865 1.508544 3.788483 6.201268 4.602218
min 1.000000 2016.000000 18.400000 34.600000 63.400000 44.400000
25% 3.750000 2016.750000 19.100000 37.875000 71.075000 49.200000
50% 6.500000 2017.500000 19.800000 39.400000 75.850000 51.100000
75% 9.250000 2018.250000 20.700000 42.950000 79.975000 54.375000
max 12.000000 2019.000000 27.100000 48.700000 90.400000 63.200000



SI02  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 19.983333 45.200000 75.625000 55.327083
std 3.488583 1.129865 1.815926 4.155591 5.734943 4.641521
min 1.000000 2016.000000 17.400000 37.700000 64.100000 47.200000
25% 3.750000 2016.750000 18.700000 42.275000 72.200000 52.575000
50% 6.500000 2017.500000 19.450000 44.000000 74.800000 54.050000
75% 9.250000 2018.250000 20.625000 48.350000 78.975000 57.950000
max 12.000000 2019.000000 27.300000 54.100000 88.100000 66.100000



SI03  statistics
Fiscal Month Number Fiscal Year Diversion Rate-Total (Total Recycling / Total Waste) Capture Rate-Paper (Total Paper / Max Paper) Capture Rate-MGP (Total MGP / Max MGP) Capture Rate-Total ((Total Recycling - Leaves (Recycling)) / (Max Paper + Max MGP))x100
count 48.000000 48.000000 48.000000 48.000000 48.000000 48.000000
mean 6.500000 2017.500000 21.095833 47.906250 81.429167 59.072917
std 3.488583 1.129865 2.031346 4.124778 6.349701 4.581403
min 1.000000 2016.000000 18.100000 40.500000 66.600000 51.200000
25% 3.750000 2016.750000 19.875000 44.375000 76.700000 56.375000
50% 6.500000 2017.500000 20.450000 46.900000 80.950000 58.000000
75% 9.250000 2018.250000 21.650000 51.875000 86.675000 62.300000
max 12.000000 2019.000000 29.500000 55.800000 95.400000 69.200000



Analysis

Using the graphs and charts that have been developed via our computer, we can now begin to analyze our data.

A majority of the Browning community lives in the Upper East Side. The Upper East Side is considered District 08 in Manhattan. Below, the graph created for the Upper East Side will be shown: alt text

Looking at this graph, we can understand that the Diversion Rate (for the Upper East Side) is considerably low. Less than 30% of all materials used in the Upper East Side is recycled. Such practices lead to an overall increase in pollution. By not recycling the materials that we use, we are exposing ourselves and other forms of life to harmful chemicals and particles that can pose a threat to our overall well-being. We are also overfilling our landfills and creating the destruction of our natural habitats.

Many members of the Browning community also live in the Upper West Side. The Upper West Side is considered District 10 in Manhattan. Below, the graph created for the Upper West Wide will be shown: alt text

Looking at this graph, we can see many similarties to the graph that was generated for the Upper East Side. The Diversion Rate Total is also considerably low with the Total Diversion Rate being less than 30%.

Also, a common trend between both of the graphs is the relative time of spikes within the graph. Those spikes are often around the summer and early winter. Such spikes are understandable because of the common influx of tourists coming into New York City. Such tourists may not know of the certain ways in which they can deposit or manage the trash that they generate.


Using the information that we can see, here are some ways to make sure that our Total Diversion Rate increase.

  1. Know what you can and cannot recycle:

    • New York has provided people with a complete list that outlines the specific rules and regulations on how to recycle a certain item (Recycling Info)
    • Many items have a symbol that implies whether an item is recyclable or not (♻️)
  2. Begin to purchase more recyceable items.

    • The world around us is surrounded with technology. However, as more people begin to use technology, technological waste also begins to increase.
      • If you have an old device that you do not use anymore, many companies have programs in which they will purchase your device from you and recycle it. Not only do you make extra money but you are also saving the world! Apple also utilizes many components of recycled phones (metal and glass) to utilize them when building new phones.
      • Begin to purchase rechargeable batteries. Rechargeable batteries allow for an overall decrease of the amount of batteries thrown out within one household. In the long run, this helps save many people spend less when purchasing batteries because they will almost never have to purchase batteries again (until the rechargeable battery wears out).
    • Begin to transition from one-time plastic items to reuseable fiber, metal, wooden items.
      • Many people are beginning to convert their usage of one-time plastic bottles to reuseable metal bottles.
      • Many people are also beginning to transition from using one-time use plastic bag to resueable fiber bags. In particular, New York State has mandated a state-wide law on the banning on plastic bag. However, because this is a recent change (as of March 1, 2020), we have not been able to see the major effects that this law has put on the overall enviornment.
      • As a community, a shift in the common items that we use can prove to be extremely helpful towards the world that we live in.
  3. Begin to sort out your garbage.

    • Create separate areas for regular trash and recycled trash. This will allow for both you and your family members to make concious decisions on what they are putting into the trash can.
    • Also, in New York City, most streets have multiple slots for which you can deposit your trash based on the type of trash that you are throwing out.
    • Also, if you have any clothes or items that you either are not interested in or do not wear anymore, please remember to donate such items. Not only do they help someone in need, but they also allow for the reduction of waste for such items.

Thank you for viewing my project! If you have any further questions, please email Washieu Anan (wanan@browning.edu).